/*
 Navicat Premium Data Transfer

 Source Server         : ali-mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : 39.107.92.215:3306
 Source Schema         : mall-sys

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/11/2021 15:31:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_spec_group
-- ----------------------------
DROP TABLE IF EXISTS `tb_spec_group`;
CREATE TABLE `tb_spec_group` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `cid` bigint NOT NULL COMMENT '商品分类id，一个分类下有多个规格组',
  `name` varchar(32) NOT NULL COMMENT '规格组的名称',
  PRIMARY KEY (`id`),
  KEY `key_category` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3 COMMENT='规格参数的分组表，每个商品分类下有多个规格参数组';

-- ----------------------------
-- Records of tb_spec_group
-- ----------------------------
BEGIN;
INSERT INTO `tb_spec_group` VALUES (1, 76, '主体');
INSERT INTO `tb_spec_group` VALUES (2, 76, '基本信息');
INSERT INTO `tb_spec_group` VALUES (3, 76, '操作系统');
INSERT INTO `tb_spec_group` VALUES (4, 76, '主芯片');
INSERT INTO `tb_spec_group` VALUES (5, 76, '存储');
INSERT INTO `tb_spec_group` VALUES (6, 76, '摄像头');
INSERT INTO `tb_spec_group` VALUES (7, 76, '电池信息');
INSERT INTO `tb_spec_group` VALUES (11, 76, '屏幕');
INSERT INTO `tb_spec_group` VALUES (12, 90, '主体');
INSERT INTO `tb_spec_group` VALUES (13, 90, '规格尺寸');
INSERT INTO `tb_spec_group` VALUES (14, 77, 'test');
INSERT INTO `tb_spec_group` VALUES (16, 334, '品牌');
INSERT INTO `tb_spec_group` VALUES (17, 334, '型号');
INSERT INTO `tb_spec_group` VALUES (18, 326, '主体');
INSERT INTO `tb_spec_group` VALUES (19, 326, '操作系统');
INSERT INTO `tb_spec_group` VALUES (20, 326, '处理器');
INSERT INTO `tb_spec_group` VALUES (21, 326, '内存');
INSERT INTO `tb_spec_group` VALUES (22, 326, '硬盘');
INSERT INTO `tb_spec_group` VALUES (23, 326, '显卡');
INSERT INTO `tb_spec_group` VALUES (24, 326, '显示器');
INSERT INTO `tb_spec_group` VALUES (25, 326, '通信');
INSERT INTO `tb_spec_group` VALUES (26, 326, '端口');
INSERT INTO `tb_spec_group` VALUES (27, 326, '电源');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
